#! /usr/bin/env python
# -*- coding: utf-8 -*-

company_name = '福建优力特材料有限公司'
company_id = '1820379858379681793'
object_name = '测试分析分析对象-xmj'
object_id = '1904078008189706241'
unit_name = '包保责任单元'
unit_id = '1904078008403615746'

query_sql = '''
SELECT
	count(*) 
FROM
	hgyq_emergency.dual_m_pla_con_aud_task 
WHERE
	create_dept = ''' + company_id + '''  
	AND obj_id = ''' + object_id + ''' 
	AND unit_id = ''' + unit_id + ''' 
	AND is_deleted = 0
	AND type = 2
'''

reset_sql = '''
SELECT
	count(*) 
FROM
	hgyq_emergency.dual_m_pla_con_aud_task 
WHERE
	create_dept = ''' + company_id + '''  
	AND is_deleted = 0
	AND type = 2
'''
